Release 10.1A: OpenEdge Data Management:
Database Administration

Dumping selective contents with PROUTIL

A selective binary dump allows you to specify that only records matching your criteria are dumped. Use the following syntax to perform a selective binary dump:

proutil db-name -C dumpspecified      [owner-name.]table-name.field-name operator field-value directory

In the syntax, db-name specifies the database from which you want to dump; owner-name specifies the owner of the table containing the data you want to dump; table-name specifies the name of the table containing the data you want to dump; field-name specifies the index you are using to select the records to dump; operator specifies the comparison to make when selecting records; field-value specifies the value against which the filed contents will be compared; and directory specifies the name of the target directory where the data will be written.

Operator can be one of five values:

EQ — equal to.
GT — greater than.
GE — greater than or equal to.
LT — less than.
LE — less than or equal to.

For the complete syntax for selective binary dumps, see the "PROUTIL DUMPSPECIFIED qualifier" section.

Examples

The following syntax dumps all order date values greater than 2/3/02 from the Sports2000 database:

proutil sports2000 -C dumpspecified order.order_date GT ’02-03-2002’

The following syntax dumps all item prices less than $25.90 from the Sports2000 database:

proutil sports2000 -C dumpspecified item.price LT 25.9

The following syntax dumps all order ship dates of 12/24/01 from the Sports2000 database into the /dev/results directory:

proutil sports2000 -C dumpspecified order.ship_date EQ ’12-24-2001’ /dev/results

The following syntax dumps all back ordered items from the Sports2000 database into the /inventory/warehouse1 directory:

proutil sports2000 -C dumpspecified order_line.backorder EQ yes /inventory/warehouse1